UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZMibrqABIMMGmhVblR58f0bxAY7hpIJpIz3NMwbh18='
WHERE
key_id = 'b8f1326c75fcf88aa12f036b0d05e0b9da962fef99652ddab787e75d5a30c720'
AND (
token = '7ZMibrqABIMMGmhVblR58f0bxAY7hpIJpIz3NMwbh18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)