UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3B9eZjnfW5bJkjGmTZNQFV6N2BdOT90wbVlkKW22rUQ='
WHERE
key_id = '2b9c783cc8a6626f094899e2087e94b75c8bb846f3a7b53de796614165194fdc'
AND (
token = '3B9eZjnfW5bJkjGmTZNQFV6N2BdOT90wbVlkKW22rUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)