UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xhxp7jVIj7b2CNmceD2O3j483AmqKl9jxnNnZce/z+0='
WHERE
key_id = 'ee8fcd9e99f3993555ac37eabceb44e15f1c769e13d27b7dfdd7c1c864859aa3'
AND (
token = 'xhxp7jVIj7b2CNmceD2O3j483AmqKl9jxnNnZce/z+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)