UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MCPPH2L+0UcAwy1zGvhxYT3376YOVPyuQHvUf/pCuWM='
WHERE
key_id = '6c6ec2ba7d6fba8015d0defb9a97a9b84f90c71e72e54dc79a21cecd63ff3d88'
AND (
token = 'MCPPH2L+0UcAwy1zGvhxYT3376YOVPyuQHvUf/pCuWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)