UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/L7WBXYCnm360XP9snI/PHkfqU/bFxIwK9o815btAhg='
WHERE
key_id = 'af657bda1a6f61949b5c1751fbdaad876ce43609414e285a49619bc09426c820'
AND (
token = '/L7WBXYCnm360XP9snI/PHkfqU/bFxIwK9o815btAhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)