UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMlSp0q0j6M+lHfbmnH6vARS55pnyyYpSmd5H+6AN+Y='
WHERE
key_id = 'fc9148286c7c0d48f26f09a53fe4859d05562b3d4dbe5fd1dc01112b4c23df2f'
AND (
token = 'zMlSp0q0j6M+lHfbmnH6vARS55pnyyYpSmd5H+6AN+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)