UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XN8WxeJ7UbQFqdqUE21dZV41frE4bMXeE7bKSFkTXBw='
WHERE
key_id = 'c76e77f31a4fa9f1247293060b656cfb8ad3a31b17231e51b7d43e10a84be0ef'
AND (
token = 'XN8WxeJ7UbQFqdqUE21dZV41frE4bMXeE7bKSFkTXBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)