UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fDSxAsZ3gu681wTB2heIjWUud9y9svfX4k+g602eE7I='
WHERE
key_id = 'cae0a00bd03862e1eb96103a8a0d947b567bda5699f5c0c04137609f7fff2e67'
AND (
token = 'fDSxAsZ3gu681wTB2heIjWUud9y9svfX4k+g602eE7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)