UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gBjPn2PFLLc7CIcNApRY/KWX9qRWpJ5kYp5zyiP0SY='
WHERE
key_id = 'db41230a1b7a53ed63aa8121da931c1bd144e710fd9a0f13e103b183370d200c'
AND (
token = '0gBjPn2PFLLc7CIcNApRY/KWX9qRWpJ5kYp5zyiP0SY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)