UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mAD5xQaaR1h0o+C0NVlzZAhTkqWnSVtFapeNuRiAOY8='
WHERE
key_id = '34e3cf27b14d14a23be517aa5a1f45afa8ecb87151d8a1366525618dc4f3bfb7'
AND (
token = 'mAD5xQaaR1h0o+C0NVlzZAhTkqWnSVtFapeNuRiAOY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)