UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j1UB9Zy6sAL0APYYBcjuoKGvZeZAPVpJoivukmYQ7ww='
WHERE
key_id = '7c104e00e3faae8b95ddf9ff5c90851766a63420eb446240c9d197c54a1ce7bd'
AND (
token = 'j1UB9Zy6sAL0APYYBcjuoKGvZeZAPVpJoivukmYQ7ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)