UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+C7zIQ2HXIKoJ5vlIhRQllXYr1orYhk23FhOsEnnoCI='
WHERE
key_id = '5a2045d4ce868cbcbecc6a588febfb5234efce009272369fe715686890516b9a'
AND (
token = '+C7zIQ2HXIKoJ5vlIhRQllXYr1orYhk23FhOsEnnoCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)