UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/kIofEO2Hzr4ISKwnRbbDOngCUpX+JwqvAktkIURAA='
WHERE
key_id = '47cdbd56d81db1d82d3e975ff8c3c70dcccd29cdc951d2a4a4a2e53a8e0798a9'
AND (
token = 'H/kIofEO2Hzr4ISKwnRbbDOngCUpX+JwqvAktkIURAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)