UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8r4N+c5/tXMDtjOwedcPAZ/pqGT4/LiPm0yKsDjvQM='
WHERE
key_id = '518e2192fefc5439e5f4d234670daa8679938427be4c5bacb0049d6439005623'
AND (
token = 'b8r4N+c5/tXMDtjOwedcPAZ/pqGT4/LiPm0yKsDjvQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)