UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l04L+QttquAaTXfHYZ1G0qG/xO1y1XBUqb6ebNL+ETc='
WHERE
key_id = '8e023bc998552eed2ab0247a21ea4ad7673cbee44c6622b712554859ec87fbf5'
AND (
token = 'l04L+QttquAaTXfHYZ1G0qG/xO1y1XBUqb6ebNL+ETc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)