UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKv+f0ThM1zk+FYhq1keRXChsyp1czOKRpmq3PxVNf8='
WHERE
key_id = 'b409b68074ac7d9ab68072d97570287fc26e811751019d3e5d295eeb6c406a25'
AND (
token = 'ZKv+f0ThM1zk+FYhq1keRXChsyp1czOKRpmq3PxVNf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)