UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4WJfcV3fZSaiLcLDr043Y70N/oxXZgMicnuAU5aFTUM='
WHERE
key_id = 'b7ccd468f063dd33844558bc6ddadde4ebaeea6dd1c73dec9bf8d8bd715f9586'
AND (
token = '4WJfcV3fZSaiLcLDr043Y70N/oxXZgMicnuAU5aFTUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)