UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cr7+I3vqW+lfwF//2gupQ5rPPxhc5Ft+85cyLmvK9i0='
WHERE
key_id = '5a49157ce4bcc7bd0bb6544a21351ff46b1158df9c0d665d9fef557461194fca'
AND (
token = 'cr7+I3vqW+lfwF//2gupQ5rPPxhc5Ft+85cyLmvK9i0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)