UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L6/yiu8t2Pm1iCuf0HObMzobcnbvbJXeiaWJECgJmqc='
WHERE
key_id = 'bdc4a1e52f493c4d618ee71cd5689285983f066343e1351ab46e834a018e274e'
AND (
token = 'L6/yiu8t2Pm1iCuf0HObMzobcnbvbJXeiaWJECgJmqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)