UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXJvb2dfg3qZ2mY/MBlfiRbUMTj0cU7bW0WEhpq5kPM='
WHERE
key_id = '08b333f499d1624f4e923f4ab4a98cd511477c7081e387ffc94ccad8ac77ed7b'
AND (
token = 'pXJvb2dfg3qZ2mY/MBlfiRbUMTj0cU7bW0WEhpq5kPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)