UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P4qF9wkosLGonvfvi54T7+YeSUikJf56OvqFh7LEIjY='
WHERE
key_id = 'a8ef5d26444559ef99562934774689052424624627bb48d0517b0a55d0cc5cae'
AND (
token = 'P4qF9wkosLGonvfvi54T7+YeSUikJf56OvqFh7LEIjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)