UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L4vz2c+6BbvjBltJiEsl7Svh9YLODCYTk/nTAJbY8SA='
WHERE
key_id = '4f23d1763699c4520e29b438f3ad6e3e375235219c51ade64050234b5f2c5e4a'
AND (
token = 'L4vz2c+6BbvjBltJiEsl7Svh9YLODCYTk/nTAJbY8SA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)