UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w9/BGdrvj/XRN0ZV41MH3rVvI0aRh59iS0MlwVgEjJ8='
WHERE
key_id = 'd396bc56a5eea839583582cd499d50ba3c670c00506004cc5bc4b657ff5b7ff8'
AND (
token = 'w9/BGdrvj/XRN0ZV41MH3rVvI0aRh59iS0MlwVgEjJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)