UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oF6JBXeSrNJhYtI7g+YaOzIRUY6EKn5OWONU2CSrWyM='
WHERE
key_id = 'b8e46c7a3852e1fd7c9d400170230820711d05eb8a6048d048bebd5bf008dd50'
AND (
token = 'oF6JBXeSrNJhYtI7g+YaOzIRUY6EKn5OWONU2CSrWyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)