UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iBmgKWl7oBE5TgZcWCiK6EPO+2Zv+4awisKmrkqnCY4='
WHERE
key_id = '4e0f1e4ed4e633b36ae33c0b84d66038b285a7b21bfe07fad3a731ce37238104'
AND (
token = 'iBmgKWl7oBE5TgZcWCiK6EPO+2Zv+4awisKmrkqnCY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)