UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K12LXl3+QPqCCbSwHUJN71iveouM7SZ5HCrm6X1ecE8='
WHERE
key_id = 'fc8e358d509bab5774eab00fa154df80be625a6c22f02d4ecc32c9d897bd22f8'
AND (
token = 'K12LXl3+QPqCCbSwHUJN71iveouM7SZ5HCrm6X1ecE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)