UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9Qmu4+B+W5zl+beK6/59Z5U6aAQngtCXN3Dezf+ja8='
WHERE
key_id = 'bbfcccf5db69350f27732a83e82267d83f912146f21fed37fd2b92c9487f2872'
AND (
token = 'o9Qmu4+B+W5zl+beK6/59Z5U6aAQngtCXN3Dezf+ja8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)