UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9EbUPyiYtlacIsgTh7Gj8t+o/H7p9u3YLqGFvA/LUAg='
WHERE
key_id = 'b9fab92ffeedf1a3d0cadd6a4290ae79344069c4b1e1f26d6a0a723da3ac8416'
AND (
token = '9EbUPyiYtlacIsgTh7Gj8t+o/H7p9u3YLqGFvA/LUAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)