UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B92/MFXHIGf1Sw1OF7+9XEY/2mslMLP5I/gqjTTY71w='
WHERE
key_id = '7b289763044067ae9136b69469256b9bcf535270e2df168cc60d0eedfe7a56a7'
AND (
token = 'B92/MFXHIGf1Sw1OF7+9XEY/2mslMLP5I/gqjTTY71w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)