UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p12SVwMQC1FTSQxSlWfTEUO2I5UlZ4fLnC4hNzrq1Fs='
WHERE
key_id = 'fe288a191d0326706b0a0af58bbe4f389707651ad94cd1eafd7c67288f32f956'
AND (
token = 'p12SVwMQC1FTSQxSlWfTEUO2I5UlZ4fLnC4hNzrq1Fs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)